1 <?php
2 require("../includes/config.php");
3 session_start();
4 if(isset($_SESSION['admin_login'])) {
5 $order_id = $_GET['id'];
6 $query_selectManOrderItems = "SELECT *,order_items.quantity as quantity FROM orders,order_items,products WHERE order_items.order_id='$order_id' AND order_items.pro_id=products.pro_id AND order_items.order_id=orders.order_id";
7 $result_selectManOrderItems = mysqli_query($con,$query_selectManOrderItems);
8 $query_selectManOrder = "SELECT date,approved,status FROM orders WHERE order_id='$order_id'";
9 $result_selectManOrder = mysqli_query($con,$query_selectManOrder);
10 $row_selectManOrder = mysqli_fetch_array($result_selectManOrder);
11 }
12 else {
13 header('Location:../index.php');
14 }
15 ?>
16
17 <!DOCTYPE html>
18 <html>
19 <head>
20 <title> View Orders </title>
21 <link rel="stylesheet" href="../includes/main_style.css" >
22 </head>
23 <body>
24 <?php
25 include("../includes/header.inc.php");
26 include("../includes/nav_admin.inc.php");
27 include("../includes/aside_admin.inc.php");
28 ?>
29 <section>
30 <h1>Order Details</h1>
31 <table class="table_infoFormat">
32 <tr>
33 <td> Order No: </td>
34 <td> <?php echo $order_id; ?> </td>
35 </tr>
36 <tr>
37 <td> Status: </td>
38 <td>
39 <?php
40 if($row_selectManOrder['status'] == 0) {
41 echo "Pending";
42 }
43 else {
44 echo "Completed";
45 }
46 ?>
47 </td>
48 </tr>
49 <tr>
50 <td> Date: </td>
51 <td> <?php echo date("d-m-Y",strtotime($row_selectManOrder['date'])); ?> </td>
52 </tr>
53 </table>
54 <form action="" method="POST" class="form">
55 <table class="table_invoiceFormat">
56 <tr>
57 <th> Products </th>
58 <th> Unit Price </th>
59 <th> Quantity </th>
60 <th> Amount </th>
61 </tr>
62 <?php $i=1; while($row_selectManOrderItems = mysqli_fetch_array($result_selectManOrderItems)) { ?>
63 <tr>
64 <td> <?php echo $row_selectManOrderItems['pro_name']; ?> </td>
65 <td> <?php echo $row_selectManOrderItems['pro_price']; ?> </td>
66 <td> <?php echo $row_selectManOrderItems['quantity']; ?> </td>
67 <td> <?php echo $row_selectManOrderItems['quantity']*$row_selectManOrderItems['pro_price']; ?> </td>
68 </tr>
69 <?php $i++; } ?>
70 <tr style="height:40px;vertical-align:bottom;">
71 <td colspan="3" style="text-align:right;"> Total Amount: </td>
72 <td>
73 <?php
74 mysqli_data_seek($result_selectManOrderItems,0);
75 $row_selectManOrderItems = mysqli_fetch_array($result_selectManOrderItems);
76 echo $row_selectManOrderItems['total_amount'];
77 ?>
78 </td>
79 </tr>
80 </table>
81 </form>
82 </section>
83 <?php
84 include("../includes/footer.inc.php");
85 ?>
86 </body>
87 </html>
